Problem Note 49177: Procedures that are run using SAS® In-Database give "Base table or view already exists" errors
 |  |  |  |  |
When you use SAS In-Database to run the procedures DMREG, DMDB, or DMINE, the following error might occur:
TERADATA_12: Executed: on connection 2 62 1350568771 trexec 0 SQL commit work; 63 1350568771 trexec 0 SQL 64 1350568771 trexec 0 SQL ERROR: Begin messages from the DBMS. ERROR: Error code = 3803. ERROR: SQL state from the DBMS 42S01. ERROR: Base table or view already exists Table 'olsInfo' already exists. ERROR: End messages from the DBMS. TERADATA: trforc: COMMIT WORK 65 1350568776 trforc 0 DMREG
Permanent data tables are created in the database as the procedure runs. The problem occurs when another user ID runs the same procedure concurrently on the same database.
To work around the problem, ensure that multiple user IDs are not running the same procedure at the same time on the same database.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | Windows Vista for x64 | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 |
| Windows Vista | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Windows 7 Ultimate x64 | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Windows 7 Professional x64 | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Windows 7 Professional 32 bit | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Windows 7 Home Premium x64 | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Windows 7 Enterprise x64 | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Microsoft Windows XP Professional | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| 64-bit Enabled HP-UX | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| HP-UX IPF | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Linux | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Linux for x64 | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| Solaris for x64 | 9.3_M1 | 9.3_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
A fix for this issue for SAS Enterprise Miner 12.1_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J33.html#49177
Procedures that are run using SAS® In-Database give "Base table or view already exists" errors
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Data Mining Data Management ==> Data Sources ==> External Databases ==> Teradata |
| Date Modified: | 2014-01-29 14:43:03 |
| Date Created: | 2013-02-15 10:43:25 |